package com.tanhua.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.model.db.Log;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface LogMapper extends BaseMapper<Log> {
    /*
    * 根据日期和类型统计总数
    *
    * */
    @Select("select count(distinct user_id) from tb_log where type = #{type} and log_time = #{logTime}")
    Integer queryByLogTimeAndType(@Param("type") String type,@Param("logTime") String logTime);

    /*
    * 根据日期统计总数
    *
    * */
    @Select("select count(distinct user_id) from tb_log where  log_time = #{logTime}")
    Integer queryByLogTime(String logTime);


    /*
    *   统计次日留存数量
    *
    * */
    @Select("select count(distinct user_id) from tb_log where log_time=#{today} and user_id in (\n" +
            "\t select user_id from tb_log where log_time=#{yesterday}  and type='0102'\n" +
            ")")
    Integer queryNumRetention(@Param("today") String today ,@Param("yesterday") String yesterday);
}
